Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 5446331 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.3 GiB |
| Average record size in memory | 264.8 B |
Variable types
| Numeric | 18 |
|---|---|
| Categorical | 11 |
No_Inspections is highly overall correlated with gas_natural | High correlation |
preventive_maintenance_rate is highly overall correlated with No_Incidents and 1 other fields | High correlation |
Average_MonthsLastRev is highly overall correlated with MonthsLastRev | High correlation |
MonthsLastRev is highly overall correlated with Average_MonthsLastRev | High correlation |
NumConnections is highly overall correlated with area_connection and 2 other fields | High correlation |
Relative_Thickness is highly overall correlated with Diameter2 and 1 other fields | High correlation |
pipe_area is highly overall correlated with Length2 | High correlation |
area_connection is highly overall correlated with NumConnections | High correlation |
Diameter2 is highly overall correlated with Relative_Thickness | High correlation |
Length2 is highly overall correlated with NumConnections and 1 other fields | High correlation |
Pressure2 is highly overall correlated with Relative_Thickness and 2 other fields | High correlation |
Average year Humidity (%) is highly overall correlated with Yearly Sun Hours (hours) | High correlation |
Yearly Sun Hours (hours) is highly overall correlated with Average year Humidity (%) | High correlation |
No_Incidents is highly overall correlated with preventive_maintenance_rate and 1 other fields | High correlation |
Incidence is highly overall correlated with preventive_maintenance_rate and 1 other fields | High correlation |
connection_bool is highly overall correlated with NumConnections | High correlation |
gas_natural is highly overall correlated with No_Inspections | High correlation |
Material_Acrylonitrile-Butadiene-Styrene is highly overall correlated with Pressure2 and 1 other fields | High correlation |
Material_Polyethylene is highly overall correlated with Pressure2 and 1 other fields | High correlation |
No_Incidents is highly imbalanced (97.7%) | Imbalance |
Incidence is highly imbalanced (98.5%) | Imbalance |
NumConnectionsUnder is highly imbalanced (99.9%) | Imbalance |
gas_natural is highly imbalanced (87.0%) | Imbalance |
Material_Acrylonitrile-Butadiene-Styrene is highly imbalanced (67.5%) | Imbalance |
Material_Copper is highly imbalanced (97.6%) | Imbalance |
Material_Fiberglass-Reinforced Plastic is highly imbalanced (85.9%) | Imbalance |
Material_Polyethylene is highly imbalanced (57.8%) | Imbalance |
Material_Polypropylene is highly imbalanced (96.7%) | Imbalance |
area_connection is highly skewed (γ1 = 474.6354216) | Skewed |
incidence_area is highly skewed (γ1 = 461.7287922) | Skewed |
preventive_maintenance_rate has 5414855 (99.4%) zeros | Zeros |
NumConnections has 3382310 (62.1%) zeros | Zeros |
area_connection has 3382310 (62.1%) zeros | Zeros |
incidence_area has 5438615 (99.9%) zeros | Zeros |
Reproduction
| Analysis started | 2023-02-18 21:40:13.692756 |
|---|---|
| Analysis finished | 2023-02-18 21:52:23.260588 |
| Duration | 12 minutes and 9.57 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
PipeId
Real number (ℝ)
| Distinct | 1227387 |
|---|---|
| Distinct (%) | 22.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0300577 × 108 |
| Minimum | 489616 |
|---|---|
| Maximum | 4.5199531 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 489616 |
|---|---|
| 5-th percentile | 12068423 |
| Q1 | 1.3355351 × 108 |
| median | 1.9027323 × 108 |
| Q3 | 2.9829521 × 108 |
| 95-th percentile | 3.9716302 × 108 |
| Maximum | 4.5199531 × 108 |
| Range | 4.5150569 × 108 |
| Interquartile range (IQR) | 1.647417 × 108 |
Descriptive statistics
| Standard deviation | 1.1416027 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.56234989 |
| Kurtosis | -0.74522921 |
| Mean | 2.0300577 × 108 |
| Median Absolute Deviation (MAD) | 93833945 |
| Skewness | -0.082278506 |
| Sum | 1.1056366 × 1015 |
| Variance | 1.3032568 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 310826986 | 11 | < 0.1% |
| 263765118 | 11 | < 0.1% |
| 190443521 | 11 | < 0.1% |
| 190443535 | 11 | < 0.1% |
| 190576614 | 11 | < 0.1% |
| 190576621 | 11 | < 0.1% |
| 190948042 | 11 | < 0.1% |
| 263764681 | 11 | < 0.1% |
| 263765023 | 11 | < 0.1% |
| 263765060 | 11 | < 0.1% |
| Other values (1227377) | 5446221 |
| Value | Count | Frequency (%) |
| 489616 | 5 | |
| 489645 | 5 | |
| 489780 | 5 | |
| 489790 | 5 | |
| 489792 | 5 | |
| 489793 | 5 | |
| 489981 | 5 | |
| 489982 | 5 | |
| 489996 | 5 | |
| 490308 | 4 |
| Value | Count | Frequency (%) |
| 451995309 | 4 | |
| 451995260 | 4 | |
| 451995254 | 2 | |
| 451195406 | 3 | |
| 451195391 | 4 | |
| 451195364 | 3 | |
| 451195284 | 4 | |
| 451194879 | 4 | |
| 451194601 | 4 | |
| 451194531 | 4 |
No_Inspections
Real number (ℝ)
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.8989902 |
| Minimum | 1 |
|---|---|
| Maximum | 11 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 5 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 11 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.0369869 |
|---|---|
| Coefficient of variation (CV) | 0.2116736 |
| Kurtosis | 4.6942796 |
| Mean | 4.8989902 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.87722946 |
| Sum | 26681522 |
| Variance | 1.0753418 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 3409988 | |
| 6 | 1033936 | 19.0% |
| 4 | 424427 | 7.8% |
| 3 | 268566 | 4.9% |
| 2 | 198548 | 3.6% |
| 1 | 53739 | 1.0% |
| 7 | 27636 | 0.5% |
| 10 | 15590 | 0.3% |
| 8 | 5834 | 0.1% |
| 9 | 5518 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 53739 | 1.0% |
| 2 | 198548 | 3.6% |
| 3 | 268566 | 4.9% |
| 4 | 424427 | 7.8% |
| 5 | 3409988 | |
| 6 | 1033936 | 19.0% |
| 7 | 27636 | 0.5% |
| 8 | 5834 | 0.1% |
| 9 | 5518 | 0.1% |
| 10 | 15590 | 0.3% |
| Value | Count | Frequency (%) |
| 11 | 2549 | < 0.1% |
| 10 | 15590 | 0.3% |
| 9 | 5518 | 0.1% |
| 8 | 5834 | 0.1% |
| 7 | 27636 | 0.5% |
| 6 | 1033936 | 19.0% |
| 5 | 3409988 | |
| 4 | 424427 | 7.8% |
| 3 | 268566 | 4.9% |
| 2 | 198548 | 3.6% |
No_Incidents
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.1 MiB |
| 0.0 | |
|---|---|
| 1.0 | 29505 |
| 2.0 | 1865 |
| 3.0 | 94 |
| 4.0 | 12 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 16338993 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 5414855 | |
| 1.0 | 29505 | 0.5% |
| 2.0 | 1865 | < 0.1% |
| 3.0 | 94 | < 0.1% |
| 4.0 | 12 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 5414855 | |
| 1.0 | 29505 | 0.5% |
| 2.0 | 1865 | < 0.1% |
| 3.0 | 94 | < 0.1% |
| 4.0 | 12 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 10861186 | |
| . | 5446331 | |
| 1 | 29505 | 0.2% |
| 2 | 1865 | < 0.1% |
| 3 | 94 | < 0.1% |
| 4 | 12 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10892662 | |
| Other Punctuation | 5446331 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 10861186 | |
| 1 | 29505 | 0.3% |
| 2 | 1865 | < 0.1% |
| 3 | 94 | < 0.1% |
| 4 | 12 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 5446331 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 16338993 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 10861186 | |
| . | 5446331 | |
| 1 | 29505 | 0.2% |
| 2 | 1865 | < 0.1% |
| 3 | 94 | < 0.1% |
| 4 | 12 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 16338993 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 10861186 | |
| . | 5446331 | |
| 1 | 29505 | 0.2% |
| 2 | 1865 | < 0.1% |
| 3 | 94 | < 0.1% |
| 4 | 12 | < 0.1% |
InspectionYear
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2015.5865 |
| Minimum | 2010 |
|---|---|
| Maximum | 2021 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 2010 |
|---|---|
| 5-th percentile | 2011 |
| Q1 | 2013 |
| median | 2016 |
| Q3 | 2018 |
| 95-th percentile | 2020 |
| Maximum | 2021 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.9048527 |
|---|---|
| Coefficient of variation (CV) | 0.0014411948 |
| Kurtosis | -1.1783153 |
| Mean | 2015.5865 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.094194503 |
| Sum | 1.0977551 × 1010 |
| Variance | 8.4381691 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2019 | 590240 | |
| 2017 | 589947 | |
| 2018 | 556874 | |
| 2020 | 553505 | |
| 2016 | 539475 | |
| 2015 | 534623 | |
| 2012 | 528261 | |
| 2014 | 512780 | |
| 2013 | 503194 | |
| 2011 | 454474 | |
| Other values (2) | 82958 | 1.5% |
| Value | Count | Frequency (%) |
| 2010 | 81842 | 1.5% |
| 2011 | 454474 | |
| 2012 | 528261 | |
| 2013 | 503194 | |
| 2014 | 512780 | |
| 2015 | 534623 | |
| 2016 | 539475 | |
| 2017 | 589947 | |
| 2018 | 556874 | |
| 2019 | 590240 |
| Value | Count | Frequency (%) |
| 2021 | 1116 | < 0.1% |
| 2020 | 553505 | |
| 2019 | 590240 | |
| 2018 | 556874 | |
| 2017 | 589947 | |
| 2016 | 539475 | |
| 2015 | 534623 | |
| 2014 | 512780 | |
| 2013 | 503194 | |
| 2012 | 528261 |
preventive_maintenance_rate
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 44 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0050959271 |
| Minimum | 0 |
|---|---|
| Maximum | 3 |
| Zeros | 5414855 |
| Zeros (%) | 99.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 3 |
| Range | 3 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.074123837 |
|---|---|
| Coefficient of variation (CV) | 14.545702 |
| Kurtosis | 478.49656 |
| Mean | 0.0050959271 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.133955 |
| Sum | 27754.106 |
| Variance | 0.0054943432 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5414855 | |
| 0.76 | 9999 | 0.2% |
| 0.6388888889 | 6937 | 0.1% |
| 0.72 | 2960 | 0.1% |
| 1.222222222 | 2108 | < 0.1% |
| 1.75 | 2047 | < 0.1% |
| 0.68 | 1332 | < 0.1% |
| 0.6111111111 | 992 | < 0.1% |
| 0.9375 | 978 | < 0.1% |
| 0.5833333333 | 952 | < 0.1% |
| Other values (34) | 3171 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 5414855 | |
| 0.38 | 10 | < 0.1% |
| 0.39 | 30 | < 0.1% |
| 0.4197530864 | 9 | < 0.1% |
| 0.4320987654 | 18 | < 0.1% |
| 0.46875 | 16 | < 0.1% |
| 0.484375 | 56 | < 0.1% |
| 0.5102040816 | 49 | < 0.1% |
| 0.5306122449 | 84 | < 0.1% |
| 0.5510204082 | 427 | < 0.1% |
| Value | Count | Frequency (%) |
| 3 | 494 | < 0.1% |
| 2.666666667 | 2 | < 0.1% |
| 2.5 | 8 | < 0.1% |
| 2.4375 | 4 | < 0.1% |
| 2.222222222 | 107 | < 0.1% |
| 2.04 | 30 | < 0.1% |
| 2 | 73 | < 0.1% |
| 1.92 | 10 | < 0.1% |
| 1.777777778 | 6 | < 0.1% |
| 1.75 | 2047 |
Age_pipe_at_inspection
Real number (ℝ)
| Distinct | 35 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.992784 |
| Minimum | 0 |
|---|---|
| Maximum | 34 |
| Zeros | 46811 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 7 |
| median | 12 |
| Q3 | 18 |
| 95-th percentile | 27 |
| Maximum | 34 |
| Range | 34 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 7.3800932 |
|---|---|
| Coefficient of variation (CV) | 0.56801476 |
| Kurtosis | -0.39978255 |
| Mean | 12.992784 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.42033395 |
| Sum | 70763003 |
| Variance | 54.465775 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 289568 | 5.3% |
| 11 | 285862 | 5.2% |
| 13 | 280207 | 5.1% |
| 10 | 279648 | 5.1% |
| 14 | 265808 | 4.9% |
| 9 | 261922 | 4.8% |
| 15 | 255356 | 4.7% |
| 8 | 252612 | 4.6% |
| 16 | 237944 | 4.4% |
| 7 | 224358 | 4.1% |
| Other values (25) | 2813046 |
| Value | Count | Frequency (%) |
| 0 | 46811 | 0.9% |
| 1 | 142944 | |
| 2 | 167313 | |
| 3 | 184655 | |
| 4 | 209132 | |
| 5 | 195788 | |
| 6 | 220917 | |
| 7 | 224358 | |
| 8 | 252612 | |
| 9 | 261922 |
| Value | Count | Frequency (%) |
| 34 | 10234 | 0.2% |
| 33 | 14484 | 0.3% |
| 32 | 23183 | 0.4% |
| 31 | 28597 | 0.5% |
| 30 | 37852 | |
| 29 | 42860 | |
| 28 | 55513 | |
| 27 | 63538 | |
| 26 | 76847 | |
| 25 | 84059 |
pipe_inspected_frequently
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.1 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5446331 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 4692360 | |
| 0 | 753971 | 13.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 4692360 | |
| 0 | 753971 | 13.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 4692360 | |
| 0 | 753971 | 13.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5446331 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4692360 | |
| 0 | 753971 | 13.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5446331 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 4692360 | |
| 0 | 753971 | 13.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5446331 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 4692360 | |
| 0 | 753971 | 13.8% |
Average_MonthsLastRev
Real number (ℝ)
| Distinct | 521 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.125285 |
| Minimum | 0 |
|---|---|
| Maximum | 77.5 |
| Zeros | 626 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 22.166667 |
| median | 23.75 |
| Q3 | 24 |
| 95-th percentile | 24.333333 |
| Maximum | 77.5 |
| Range | 77.5 |
| Interquartile range (IQR) | 1.8333333 |
Descriptive statistics
| Standard deviation | 2.2815171 |
|---|---|
| Coefficient of variation (CV) | 0.098658983 |
| Kurtosis | 23.116717 |
| Mean | 23.125285 |
| Median Absolute Deviation (MAD) | 0.45 |
| Skewness | 0.45519165 |
| Sum | 1.2594796 × 108 |
| Variance | 5.2053203 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24 | 1769271 | |
| 24.2 | 401542 | 7.4% |
| 23.6 | 297025 | 5.5% |
| 22 | 256109 | 4.7% |
| 23.8 | 183863 | 3.4% |
| 23.4 | 159475 | 2.9% |
| 23 | 154310 | 2.8% |
| 21 | 109728 | 2.0% |
| 23.2 | 109638 | 2.0% |
| 22.2 | 102293 | 1.9% |
| Other values (511) | 1903077 |
| Value | Count | Frequency (%) |
| 0 | 626 | |
| 1 | 80 | < 0.1% |
| 2 | 117 | < 0.1% |
| 3 | 246 | < 0.1% |
| 4 | 283 | |
| 5 | 355 | |
| 6 | 353 | |
| 6.5 | 16 | < 0.1% |
| 7 | 323 | |
| 7.5 | 18 | < 0.1% |
| Value | Count | Frequency (%) |
| 77.5 | 1 | < 0.1% |
| 76 | 1 | < 0.1% |
| 75 | 1 | < 0.1% |
| 70 | 2 | < 0.1% |
| 69 | 1 | < 0.1% |
| 68.5 | 2 | < 0.1% |
| 67.5 | 3 | < 0.1% |
| 67 | 4 | < 0.1% |
| 66.5 | 5 | < 0.1% |
| 66 | 20 |
MonthsLastRev
Real number (ℝ)
| Distinct | 40 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.992876 |
| Minimum | 0 |
|---|---|
| Maximum | 39 |
| Zeros | 991 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 23 |
| median | 24 |
| Q3 | 24 |
| 95-th percentile | 25 |
| Maximum | 39 |
| Range | 39 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 3.0592022 |
|---|---|
| Coefficient of variation (CV) | 0.13305 |
| Kurtosis | 14.436309 |
| Mean | 22.992876 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.9752117 |
| Sum | 1.2522681 × 108 |
| Variance | 9.358718 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24 | 2945518 | |
| 23 | 768204 | 14.1% |
| 22 | 476271 | 8.7% |
| 25 | 451794 | 8.3% |
| 21 | 247992 | 4.6% |
| 20 | 79017 | 1.5% |
| 26 | 45677 | 0.8% |
| 19 | 41509 | 0.8% |
| 18 | 39943 | 0.7% |
| 17 | 34166 | 0.6% |
| Other values (30) | 316240 | 5.8% |
| Value | Count | Frequency (%) |
| 0 | 991 | < 0.1% |
| 1 | 1675 | < 0.1% |
| 2 | 2420 | < 0.1% |
| 3 | 4453 | 0.1% |
| 4 | 4661 | 0.1% |
| 5 | 8002 | |
| 6 | 9088 | |
| 7 | 9475 | |
| 8 | 9415 | |
| 9 | 16787 |
| Value | Count | Frequency (%) |
| 39 | 1037 | < 0.1% |
| 38 | 428 | < 0.1% |
| 37 | 899 | < 0.1% |
| 36 | 5661 | |
| 35 | 2728 | 0.1% |
| 34 | 3650 | 0.1% |
| 33 | 3488 | 0.1% |
| 32 | 7881 | |
| 31 | 4343 | 0.1% |
| 30 | 12355 |
Incidence
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.1 MiB |
| 0.0 | |
|---|---|
| 1.0 | 7716 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 16338993 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 5438615 | |
| 1.0 | 7716 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 5438615 | |
| 1.0 | 7716 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 10884946 | |
| . | 5446331 | |
| 1 | 7716 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10892662 | |
| Other Punctuation | 5446331 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 10884946 | |
| 1 | 7716 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 5446331 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 16338993 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 10884946 | |
| . | 5446331 | |
| 1 | 7716 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 16338993 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 10884946 | |
| . | 5446331 | |
| 1 | 7716 | < 0.1% |
NumConnections
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 34 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.78585106 |
| Minimum | 0 |
|---|---|
| Maximum | 34 |
| Zeros | 3382310 |
| Zeros (%) | 62.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 34 |
| Range | 34 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.5105416 |
|---|---|
| Coefficient of variation (CV) | 1.9221729 |
| Kurtosis | 22.226989 |
| Mean | 0.78585106 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.6867653 |
| Sum | 4280005 |
| Variance | 2.2817359 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3382310 | |
| 1 | 1124787 | 20.7% |
| 2 | 447037 | 8.2% |
| 3 | 204385 | 3.8% |
| 4 | 113491 | 2.1% |
| 5 | 64384 | 1.2% |
| 6 | 39757 | 0.7% |
| 7 | 23239 | 0.4% |
| 8 | 15871 | 0.3% |
| 9 | 10236 | 0.2% |
| Other values (24) | 20834 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 3382310 | |
| 1 | 1124787 | 20.7% |
| 2 | 447037 | 8.2% |
| 3 | 204385 | 3.8% |
| 4 | 113491 | 2.1% |
| 5 | 64384 | 1.2% |
| 6 | 39757 | 0.7% |
| 7 | 23239 | 0.4% |
| 8 | 15871 | 0.3% |
| 9 | 10236 | 0.2% |
| Value | Count | Frequency (%) |
| 34 | 5 | < 0.1% |
| 33 | 10 | < 0.1% |
| 32 | 2 | < 0.1% |
| 30 | 10 | < 0.1% |
| 29 | 17 | < 0.1% |
| 28 | 38 | |
| 27 | 19 | |
| 26 | 29 | |
| 25 | 17 | < 0.1% |
| 24 | 44 |
NumConnectionsUnder
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.1 MiB |
| 0 | |
|---|---|
| 1 | 811 |
| 2 | 20 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5446331 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5445500 | |
| 1 | 811 | < 0.1% |
| 2 | 20 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5445500 | |
| 1 | 811 | < 0.1% |
| 2 | 20 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5445500 | |
| 1 | 811 | < 0.1% |
| 2 | 20 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5446331 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5445500 | |
| 1 | 811 | < 0.1% |
| 2 | 20 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5446331 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5445500 | |
| 1 | 811 | < 0.1% |
| 2 | 20 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5446331 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5445500 | |
| 1 | 811 | < 0.1% |
| 2 | 20 | < 0.1% |
Relative_Thickness
Real number (ℝ)
| Distinct | 251 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5627146 |
| Minimum | 0.0015875 |
|---|---|
| Maximum | 24.384 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0.0015875 |
|---|---|
| 5-th percentile | 0.0126 |
| Q1 | 0.0225 |
| median | 0.6 |
| Q3 | 1.1 |
| 95-th percentile | 8 |
| Maximum | 24.384 |
| Range | 24.382413 |
| Interquartile range (IQR) | 1.0775 |
Descriptive statistics
| Standard deviation | 2.5425542 |
|---|---|
| Coefficient of variation (CV) | 1.6270112 |
| Kurtosis | 3.7104332 |
| Mean | 1.5627146 |
| Median Absolute Deviation (MAD) | 0.5775 |
| Skewness | 2.0616556 |
| Sum | 8511061.1 |
| Variance | 6.464582 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.7333333333 | 629816 | 11.6% |
| 0.01575 | 599884 | 11.0% |
| 0.0225 | 481142 | 8.8% |
| 4.4 | 340464 | 6.3% |
| 6.4 | 305922 | 5.6% |
| 0.6 | 282696 | 5.2% |
| 1.066666667 | 246598 | 4.5% |
| 0.0275 | 226677 | 4.2% |
| 8 | 201639 | 3.7% |
| 0.42 | 195813 | 3.6% |
| Other values (241) | 1935680 |
| Value | Count | Frequency (%) |
| 0.0015875 | 337 | < 0.1% |
| 0.00238125 | 12 | < 0.1% |
| 0.0025 | 4 | < 0.1% |
| 0.00275 | 30 | < 0.1% |
| 0.003 | 368 | < 0.1% |
| 0.003175 | 35998 | |
| 0.0032 | 3 | < 0.1% |
| 0.0035 | 9 | < 0.1% |
| 0.00375 | 794 | < 0.1% |
| 0.00381 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 24.384 | 26 | < 0.1% |
| 20.32 | 32 | < 0.1% |
| 20 | 102 | < 0.1% |
| 18.288 | 8 | < 0.1% |
| 16.256 | 490 | < 0.1% |
| 16 | 540 | < 0.1% |
| 14.224 | 10 | < 0.1% |
| 14.2 | 11 | < 0.1% |
| 14 | 372 | < 0.1% |
| 12.6 | 30002 |
pipe_area
Real number (ℝ)
| Distinct | 401305 |
|---|---|
| Distinct (%) | 7.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.4250864 |
| Minimum | 0.000502656 |
|---|---|
| Maximum | 189.60639 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0.000502656 |
|---|---|
| 5-th percentile | 0.28721764 |
| Q1 | 1.1803519 |
| median | 3.9221965 |
| Q3 | 11.58509 |
| 95-th percentile | 30.748096 |
| Maximum | 189.60639 |
| Range | 189.60589 |
| Interquartile range (IQR) | 10.404738 |
Descriptive statistics
| Standard deviation | 11.016982 |
|---|---|
| Coefficient of variation (CV) | 1.3076403 |
| Kurtosis | 8.6745535 |
| Mean | 8.4250864 |
| Median Absolute Deviation (MAD) | 3.3147776 |
| Skewness | 2.4531382 |
| Sum | 45885809 |
| Variance | 121.3739 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.691152 | 6940 | 0.1% |
| 0.345576 | 6308 | 0.1% |
| 0.518364 | 6243 | 0.1% |
| 0.1983166416 | 5889 | 0.1% |
| 0.251328 | 5511 | 0.1% |
| 0.1979208 | 5381 | 0.1% |
| 0.565488 | 5285 | 0.1% |
| 0.3958416 | 4942 | 0.1% |
| 0.282744 | 4544 | 0.1% |
| 1.005312 | 4206 | 0.1% |
| Other values (401295) | 5391082 |
| Value | Count | Frequency (%) |
| 0.000502656 | 1 | < 0.1% |
| 0.000518364 | 1 | < 0.1% |
| 0.0006031872 | 5 | |
| 0.000989604 | 7 | |
| 0.001005312 | 2 | < 0.1% |
| 0.0011875248 | 8 | |
| 0.0012534984 | 1 | < 0.1% |
| 0.00141372 | 2 | < 0.1% |
| 0.00143633952 | 1 | < 0.1% |
| 0.0015833664 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 189.6063922 | 5 | |
| 166.409509 | 4 | |
| 166.3345001 | 6 | |
| 166.3265205 | 5 | |
| 164.9856177 | 6 | |
| 164.1991421 | 4 | |
| 163.4761845 | 5 | |
| 162.9718697 | 4 | |
| 155.8460298 | 5 | |
| 154.4767194 | 4 |
area_connection
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 294111 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.19547282 |
| Minimum | 0 |
|---|---|
| Maximum | 1989.4321 |
| Zeros | 3382310 |
| Zeros (%) | 62.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.13434303 |
| 95-th percentile | 0.69440985 |
| Maximum | 1989.4321 |
| Range | 1989.4321 |
| Interquartile range (IQR) | 0.13434303 |
Descriptive statistics
| Standard deviation | 1.9343258 |
|---|---|
| Coefficient of variation (CV) | 9.8956253 |
| Kurtosis | 423577.85 |
| Mean | 0.19547282 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 474.63542 |
| Sum | 1064609.7 |
| Variance | 3.7416162 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3382310 | |
| 1.010505212 | 838 | < 0.1% |
| 2.52626303 | 788 | < 0.1% |
| 5.052526061 | 738 | < 0.1% |
| 0.8420876768 | 711 | < 0.1% |
| 5.042441179 | 682 | < 0.1% |
| 1.263131515 | 559 | < 0.1% |
| 1.684175354 | 558 | < 0.1% |
| 0.7217894373 | 528 | < 0.1% |
| 7.957728546 | 464 | < 0.1% |
| Other values (294101) | 2058155 |
| Value | Count | Frequency (%) |
| 0 | 3382310 | |
| 0.007715556516 | 5 | < 0.1% |
| 0.009769187457 | 5 | < 0.1% |
| 0.009792381384 | 5 | < 0.1% |
| 0.009840825945 | 5 | < 0.1% |
| 0.009911967005 | 5 | < 0.1% |
| 0.009919848549 | 5 | < 0.1% |
| 0.009930571972 | 5 | < 0.1% |
| 0.009956403025 | 5 | < 0.1% |
| 0.009956599227 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 1989.432136 | 1 | < 0.1% |
| 1929.146314 | 1 | < 0.1% |
| 1010.505212 | 2 | |
| 797.7672728 | 1 | < 0.1% |
| 530.5152364 | 2 | |
| 361.7149339 | 1 | < 0.1% |
| 360.8947186 | 3 | |
| 234.9144958 | 1 | < 0.1% |
| 226.0718337 | 1 | < 0.1% |
| 222.5938055 | 4 |
incidence_area
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 7141 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0011995106 |
| Minimum | 0 |
|---|---|
| Maximum | 142.1023 |
| Zeros | 5438615 |
| Zeros (%) | 99.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 142.1023 |
| Range | 142.1023 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1394909 |
|---|---|
| Coefficient of variation (CV) | 116.28985 |
| Kurtosis | 349428.73 |
| Mean | 0.0011995106 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 461.72879 |
| Sum | 6532.9315 |
| Variance | 0.019457712 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5438615 | |
| 3.978864273 | 16 | < 0.1% |
| 7.957728546 | 10 | < 0.1% |
| 5.052526061 | 8 | < 0.1% |
| 3.9808547 | 6 | < 0.1% |
| 21.22060946 | 6 | < 0.1% |
| 15.91545709 | 6 | < 0.1% |
| 5.305152364 | 5 | < 0.1% |
| 1.989432136 | 5 | < 0.1% |
| 3.536768243 | 5 | < 0.1% |
| Other values (7131) | 7649 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 5438615 | |
| 0.009659922876 | 1 | < 0.1% |
| 0.009667593515 | 1 | < 0.1% |
| 0.009801689822 | 1 | < 0.1% |
| 0.01009112637 | 1 | < 0.1% |
| 0.01015348424 | 1 | < 0.1% |
| 0.01017956655 | 1 | < 0.1% |
| 0.01018410014 | 1 | < 0.1% |
| 0.01019055084 | 1 | < 0.1% |
| 0.01019826426 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 142.1022955 | 1 | |
| 117.5006061 | 1 | |
| 89.91783668 | 1 | |
| 52.94563238 | 1 | |
| 51.03561678 | 1 | |
| 50.04860721 | 1 | |
| 45.60302892 | 1 | |
| 45.47273455 | 1 | |
| 41.44650284 | 1 | |
| 39.78864273 | 2 |
connection_bool
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.1 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5446331 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4507097 | |
| 1 | 939234 | 17.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4507097 | |
| 1 | 939234 | 17.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4507097 | |
| 1 | 939234 | 17.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5446331 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4507097 | |
| 1 | 939234 | 17.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5446331 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4507097 | |
| 1 | 939234 | 17.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5446331 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4507097 | |
| 1 | 939234 | 17.2% |
gas_natural
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.1 MiB |
| 1 | |
|---|---|
| 0 | 97631 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5446331 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 5348700 | |
| 0 | 97631 | 1.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 5348700 | |
| 0 | 97631 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 5348700 | |
| 0 | 97631 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5446331 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 5348700 | |
| 0 | 97631 | 1.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5446331 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 5348700 | |
| 0 | 97631 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5446331 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 5348700 | |
| 0 | 97631 | 1.8% |
Material_Acrylonitrile-Butadiene-Styrene
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.1 MiB |
| 0 | |
|---|---|
| 1 | 322993 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5446331 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5123338 | |
| 1 | 322993 | 5.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5123338 | |
| 1 | 322993 | 5.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5123338 | |
| 1 | 322993 | 5.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5446331 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5123338 | |
| 1 | 322993 | 5.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5446331 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5123338 | |
| 1 | 322993 | 5.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5446331 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5123338 | |
| 1 | 322993 | 5.9% |
Material_Copper
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.1 MiB |
| 0 | |
|---|---|
| 1 | 12680 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5446331 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5433651 | |
| 1 | 12680 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5433651 | |
| 1 | 12680 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5433651 | |
| 1 | 12680 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5446331 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5433651 | |
| 1 | 12680 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5446331 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5433651 | |
| 1 | 12680 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5446331 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5433651 | |
| 1 | 12680 | 0.2% |
Material_Fiberglass-Reinforced Plastic
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.1 MiB |
| 0 | |
|---|---|
| 1 | 108966 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5446331 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5337365 | |
| 1 | 108966 | 2.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5337365 | |
| 1 | 108966 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5337365 | |
| 1 | 108966 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5446331 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5337365 | |
| 1 | 108966 | 2.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5446331 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5337365 | |
| 1 | 108966 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5446331 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5337365 | |
| 1 | 108966 | 2.0% |
Material_Polyethylene
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.1 MiB |
| 1 | |
|---|---|
| 0 | 467541 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5446331 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 4978790 | |
| 0 | 467541 | 8.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 4978790 | |
| 0 | 467541 | 8.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 4978790 | |
| 0 | 467541 | 8.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5446331 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4978790 | |
| 0 | 467541 | 8.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5446331 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 4978790 | |
| 0 | 467541 | 8.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5446331 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 4978790 | |
| 0 | 467541 | 8.6% |
Material_Polypropylene
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 83.1 MiB |
| 0 | |
|---|---|
| 1 | 18877 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5446331 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5427454 | |
| 1 | 18877 | 0.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5427454 | |
| 1 | 18877 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5427454 | |
| 1 | 18877 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5446331 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5427454 | |
| 1 | 18877 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5446331 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5427454 | |
| 1 | 18877 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5446331 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5427454 | |
| 1 | 18877 | 0.3% |
Diameter2
Real number (ℝ)
| Distinct | 61 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.016325103 |
| Minimum | 0.0001 |
|---|---|
| Maximum | 0.37161216 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0.0001 |
|---|---|
| 5-th percentile | 0.003969 |
| Q1 | 0.0081 |
| median | 0.0121 |
| Q3 | 0.0256 |
| 95-th percentile | 0.04 |
| Maximum | 0.37161216 |
| Range | 0.37151216 |
| Interquartile range (IQR) | 0.0175 |
Descriptive statistics
| Standard deviation | 0.016951005 |
|---|---|
| Coefficient of variation (CV) | 1.0383399 |
| Kurtosis | 33.168043 |
| Mean | 0.016325103 |
| Median Absolute Deviation (MAD) | 0.008131 |
| Skewness | 3.9501492 |
| Sum | 88911.912 |
| Variance | 0.00028733656 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.0121 | 1475195 | |
| 0.003969 | 1046095 | |
| 0.0081 | 1010190 | |
| 0.0256 | 749971 | |
| 0.04 | 517842 | 9.5% |
| 0.0016 | 104193 | 1.9% |
| 0.02322576 | 81206 | 1.5% |
| 0.0625 | 67646 | 1.2% |
| 0.01032256 | 67151 | 1.2% |
| 0.00258064 | 49202 | 0.9% |
| Other values (51) | 277640 | 5.1% |
| Value | Count | Frequency (%) |
| 0.0001 | 158 | < 0.1% |
| 0.000121 | 60 | < 0.1% |
| 0.000144 | 1292 | < 0.1% |
| 0.00016129 | 11 | < 0.1% |
| 0.000169 | 105 | < 0.1% |
| 0.000196 | 43 | < 0.1% |
| 0.000225 | 4035 | |
| 0.000256 | 1070 | < 0.1% |
| 0.000324 | 6 | < 0.1% |
| 0.000361 | 3210 |
| Value | Count | Frequency (%) |
| 0.37161216 | 67 | < 0.1% |
| 0.31225744 | 46 | < 0.1% |
| 0.258064 | 2342 | |
| 0.25 | 102 | < 0.1% |
| 0.20903184 | 781 | < 0.1% |
| 0.16516096 | 4023 | |
| 0.16 | 561 | < 0.1% |
| 0.12645136 | 437 | < 0.1% |
| 0.126025 | 108 | < 0.1% |
| 0.1225 | 372 | < 0.1% |
Length2
Real number (ℝ)
| Distinct | 123379 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1163.4679 |
| Minimum | 2.5 × 10-5 |
|---|---|
| Maximum | 11142.702 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 2.5 × 10-5 |
|---|---|
| 5-th percentile | 1.004004 |
| Q1 | 13.373649 |
| median | 140.11457 |
| Q3 | 1230.4661 |
| 95-th percentile | 6300.9463 |
| Maximum | 11142.702 |
| Range | 11142.702 |
| Interquartile range (IQR) | 1217.0924 |
Descriptive statistics
| Standard deviation | 2126.2558 |
|---|---|
| Coefficient of variation (CV) | 1.8275156 |
| Kurtosis | 5.8583692 |
| Mean | 1163.4679 |
| Median Absolute Deviation (MAD) | 138.43495 |
| Skewness | 2.4614034 |
| Sum | 6.3366315 × 109 |
| Variance | 4520963.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 26243 | 0.5% |
| 1 | 25048 | 0.5% |
| 0.25 | 18213 | 0.3% |
| 2.25 | 17758 | 0.3% |
| 1.004004 | 16856 | 0.3% |
| 1.006009 | 10146 | 0.2% |
| 1.002001 | 9486 | 0.2% |
| 9 | 8566 | 0.2% |
| 4.016016 | 8540 | 0.2% |
| 1.44 | 8115 | 0.1% |
| Other values (123369) | 5297360 |
| Value | Count | Frequency (%) |
| 2.5 × 10-5 | 12 | < 0.1% |
| 3.6 × 10-5 | 19 | < 0.1% |
| 4.9 × 10-5 | 14 | < 0.1% |
| 6.4 × 10-5 | 20 | < 0.1% |
| 8.1 × 10-5 | 19 | < 0.1% |
| 0.0001 | 61 | |
| 0.000121 | 25 | |
| 0.000144 | 12 | < 0.1% |
| 0.000169 | 31 | |
| 0.000196 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 11142.70248 | 5 | < 0.1% |
| 11142.28025 | 15 | |
| 11142.06914 | 12 | |
| 11141.64692 | 10 | |
| 11141.43581 | 16 | |
| 11141.2247 | 10 | |
| 11140.8025 | 5 | < 0.1% |
| 11140.5914 | 19 | |
| 11140.3803 | 3 | < 0.1% |
| 11140.16921 | 5 | < 0.1% |
Pressure2
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.491531 |
| Minimum | 0.000625 |
|---|---|
| Maximum | 256 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0.000625 |
|---|---|
| 5-th percentile | 0.000625 |
| Q1 | 0.01 |
| median | 0.0225 |
| Q3 | 16 |
| 95-th percentile | 25 |
| Maximum | 256 |
| Range | 255.99937 |
| Interquartile range (IQR) | 15.99 |
Descriptive statistics
| Standard deviation | 53.125639 |
|---|---|
| Coefficient of variation (CV) | 3.0372207 |
| Kurtosis | 15.664085 |
| Mean | 17.491531 |
| Median Absolute Deviation (MAD) | 0.021875 |
| Skewness | 4.1424603 |
| Sum | 95264665 |
| Variance | 2822.3335 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 1599962 | |
| 0.0225 | 1539205 | |
| 0.000625 | 1038140 | |
| 0.01 | 562015 | 10.3% |
| 256 | 249621 | 4.6% |
| 25 | 158730 | 2.9% |
| 0.16 | 143759 | 2.6% |
| 2.89 | 111774 | 2.1% |
| 0.0025 | 19978 | 0.4% |
| 4 | 11814 | 0.2% |
| Other values (2) | 11333 | 0.2% |
| Value | Count | Frequency (%) |
| 0.000625 | 1038140 | |
| 0.0025 | 19978 | 0.4% |
| 0.01 | 562015 | 10.3% |
| 0.0225 | 1539205 | |
| 0.16 | 143759 | 2.6% |
| 2.89 | 111774 | 2.1% |
| 4 | 11814 | 0.2% |
| 16 | 1599962 | |
| 25 | 158730 | 2.9% |
| 100 | 6185 | 0.1% |
| Value | Count | Frequency (%) |
| 256 | 249621 | 4.6% |
| 144 | 5148 | 0.1% |
| 100 | 6185 | 0.1% |
| 25 | 158730 | 2.9% |
| 16 | 1599962 | |
| 4 | 11814 | 0.2% |
| 2.89 | 111774 | 2.1% |
| 0.16 | 143759 | 2.6% |
| 0.0225 | 1539205 | |
| 0.01 | 562015 | 10.3% |
Average year Humidity (%)
Real number (ℝ)
| Distinct | 37 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.67414297 |
| Minimum | 0.545 |
|---|---|
| Maximum | 0.80416667 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 0.545 |
|---|---|
| 5-th percentile | 0.545 |
| Q1 | 0.61833333 |
| median | 0.66833333 |
| Q3 | 0.75666667 |
| 95-th percentile | 0.79333333 |
| Maximum | 0.80416667 |
| Range | 0.25916667 |
| Interquartile range (IQR) | 0.13833333 |
Descriptive statistics
| Standard deviation | 0.081146398 |
|---|---|
| Coefficient of variation (CV) | 0.12036972 |
| Kurtosis | -1.2441021 |
| Mean | 0.67414297 |
| Median Absolute Deviation (MAD) | 0.088333333 |
| Skewness | -0.20311737 |
| Sum | 3671605.8 |
| Variance | 0.006584738 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.7566666667 | 1496607 | |
| 0.6441666667 | 536570 | 9.9% |
| 0.545 | 513519 | 9.4% |
| 0.715 | 314906 | 5.8% |
| 0.6666666667 | 308605 | 5.7% |
| 0.6683333333 | 232779 | 4.3% |
| 0.8041666667 | 194965 | 3.6% |
| 0.58 | 149988 | 2.8% |
| 0.7933333333 | 147657 | 2.7% |
| 0.625 | 146197 | 2.7% |
| Other values (27) | 1404538 |
| Value | Count | Frequency (%) |
| 0.545 | 513519 | |
| 0.5458333333 | 96932 | 1.8% |
| 0.555 | 75528 | 1.4% |
| 0.5566666667 | 53897 | 1.0% |
| 0.5583333333 | 55599 | 1.0% |
| 0.565 | 138476 | 2.5% |
| 0.5725 | 15921 | 0.3% |
| 0.5741666667 | 68208 | 1.3% |
| 0.58 | 149988 | 2.8% |
| 0.585 | 22313 | 0.4% |
| Value | Count | Frequency (%) |
| 0.8041666667 | 194965 | 3.6% |
| 0.7933333333 | 147657 | 2.7% |
| 0.7675 | 29521 | 0.5% |
| 0.7566666667 | 1496607 | |
| 0.7166666667 | 76882 | 1.4% |
| 0.715 | 314906 | 5.8% |
| 0.705 | 65058 | 1.2% |
| 0.7033333333 | 98573 | 1.8% |
| 0.6866666667 | 115543 | 2.1% |
| 0.6683333333 | 232779 | 4.3% |
Yearly Sun Hours (hours)
Real number (ℝ)
| Distinct | 37 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 105.18109 |
| Minimum | 73.3 |
|---|---|
| Maximum | 121.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 73.3 |
|---|---|
| 5-th percentile | 83.8 |
| Q1 | 104.6 |
| median | 104.6 |
| Q3 | 111.4 |
| 95-th percentile | 113.8 |
| Maximum | 121.2 |
| Range | 47.9 |
| Interquartile range (IQR) | 6.8 |
Descriptive statistics
| Standard deviation | 9.4874531 |
|---|---|
| Coefficient of variation (CV) | 0.090201127 |
| Kurtosis | 2.2501069 |
| Mean | 105.18109 |
| Median Absolute Deviation (MAD) | 5.8 |
| Skewness | -1.4841031 |
| Sum | 5.7285105 × 108 |
| Variance | 90.011767 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 104.6 | 1496607 | |
| 113.2 | 536570 | 9.9% |
| 109.7 | 513519 | 9.4% |
| 111.4 | 376813 | 6.9% |
| 99.8 | 314906 | 5.8% |
| 119.3 | 232779 | 4.3% |
| 75.9 | 160838 | 3.0% |
| 112.7 | 149988 | 2.8% |
| 83.8 | 147657 | 2.7% |
| 98.6 | 146197 | 2.7% |
| Other values (27) | 1370457 |
| Value | Count | Frequency (%) |
| 73.3 | 34127 | 0.6% |
| 75.9 | 160838 | |
| 79.8 | 29521 | 0.5% |
| 83.8 | 147657 | |
| 85.2 | 76882 | |
| 87.9 | 65058 | |
| 95.2 | 85594 | |
| 95.7 | 33899 | 0.6% |
| 96.7 | 20298 | 0.4% |
| 97.3 | 13959 | 0.3% |
| Value | Count | Frequency (%) |
| 121.2 | 12230 | 0.2% |
| 119.3 | 232779 | |
| 114.2 | 15921 | 0.3% |
| 113.8 | 29278 | 0.5% |
| 113.2 | 536570 | |
| 113 | 115543 | 2.1% |
| 112.7 | 149988 | 2.8% |
| 112.4 | 136707 | 2.5% |
| 112.3 | 32551 | 0.6% |
| 111.9 | 22313 | 0.4% |
Population density (persons/sqkm)
Real number (ℝ)
| Distinct | 38 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 365.8349 |
| Minimum | 8.6244906 |
|---|---|
| Maximum | 844.63536 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 83.1 MiB |
Quantile statistics
| Minimum | 8.6244906 |
|---|---|
| 5-th percentile | 24.985868 |
| Q1 | 88.244424 |
| median | 239.83298 |
| Q3 | 738.89129 |
| 95-th percentile | 844.63536 |
| Maximum | 844.63536 |
| Range | 836.01087 |
| Interquartile range (IQR) | 650.64687 |
Descriptive statistics
| Standard deviation | 315.6559 |
|---|---|
| Coefficient of variation (CV) | 0.86283703 |
| Kurtosis | -1.615061 |
| Mean | 365.8349 |
| Median Absolute Deviation (MAD) | 203.80628 |
| Skewness | 0.41679478 |
| Sum | 1.9924579 × 109 |
| Variance | 99638.646 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 738.8912904 | 1496607 | |
| 239.8329786 | 536570 | 9.9% |
| 844.6353557 | 513519 | 9.4% |
| 132.3046201 | 314906 | 5.8% |
| 129.6052047 | 308605 | 5.7% |
| 323.1713942 | 232779 | 4.3% |
| 141.108805 | 160838 | 3.0% |
| 138.9440724 | 149988 | 2.8% |
| 210.3711615 | 147657 | 2.7% |
| 64.19839704 | 146197 | 2.7% |
| Other values (28) | 1438665 |
| Value | Count | Frequency (%) |
| 8.624490588 | 13959 | 0.3% |
| 9.060436221 | 1556 | < 0.1% |
| 11.44334889 | 18610 | 0.3% |
| 14.24194167 | 5378 | 0.1% |
| 16.15263706 | 35306 | 0.6% |
| 19.58559006 | 4 | < 0.1% |
| 19.91070541 | 33899 | 0.6% |
| 21.4503848 | 53897 | |
| 22.17890173 | 20298 | 0.4% |
| 24.98586786 | 96932 |
| Value | Count | Frequency (%) |
| 844.6353557 | 513519 | 9.4% |
| 738.8912904 | 1496607 | |
| 323.1713942 | 232779 | 4.3% |
| 239.8329786 | 536570 | 9.9% |
| 230.7582809 | 98573 | 1.8% |
| 210.3711615 | 147657 | 2.7% |
| 167.2108871 | 29278 | 0.5% |
| 141.108805 | 160838 | 3.0% |
| 138.9440724 | 149988 | 2.8% |
| 132.3046201 | 314906 | 5.8% |
| PipeId | No_Inspections | InspectionYear | preventive_maintenance_rate | Age_pipe_at_inspection | Average_MonthsLastRev | MonthsLastRev | NumConnections | Relative_Thickness | pipe_area | area_connection | incidence_area | Diameter2 | Length2 | Pressure2 | Average year Humidity (%) | Yearly Sun Hours (hours) | Population density (persons/sqkm) | No_Incidents | pipe_inspected_frequently | Incidence | NumConnectionsUnder | connection_bool | gas_natural | Material_Acrylonitrile-Butadiene-Styrene | Material_Copper | Material_Fiberglass-Reinforced Plastic | Material_Polyethylene | Material_Polypropylene | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PipeId | 1.000 | 0.242 | -0.115 | -0.021 | -0.221 | 0.079 | 0.078 | -0.056 | 0.017 | 0.019 | -0.062 | -0.017 | 0.106 | -0.015 | 0.033 | 0.042 | 0.069 | -0.024 | 0.020 | 0.143 | 0.027 | 0.007 | 0.097 | 0.291 | 0.028 | 0.101 | 0.084 | 0.059 | 0.164 |
| No_Inspections | 0.242 | 1.000 | -0.160 | 0.014 | 0.316 | -0.212 | -0.144 | 0.053 | 0.142 | 0.164 | 0.029 | -0.010 | 0.151 | 0.115 | -0.115 | -0.134 | 0.105 | 0.148 | 0.018 | 0.155 | 0.032 | 0.011 | 0.068 | 0.519 | 0.052 | 0.161 | 0.063 | 0.072 | 0.246 |
| InspectionYear | -0.115 | -0.160 | 1.000 | 0.005 | 0.252 | -0.031 | 0.224 | 0.011 | -0.043 | -0.000 | 0.016 | -0.000 | -0.057 | 0.020 | 0.031 | -0.009 | -0.008 | -0.023 | 0.003 | 0.060 | 0.006 | 0.003 | 0.011 | 0.166 | 0.048 | 0.051 | 0.017 | 0.042 | 0.082 |
| preventive_maintenance_rate | -0.021 | 0.014 | 0.005 | 1.000 | 0.039 | -0.033 | -0.036 | 0.083 | 0.022 | 0.049 | 0.064 | 0.495 | 0.005 | 0.053 | -0.029 | -0.036 | 0.009 | 0.057 | 0.627 | 0.012 | 0.568 | 0.000 | 0.087 | 0.119 | 0.003 | 0.067 | 0.049 | 0.031 | 0.008 |
| Age_pipe_at_inspection | -0.221 | 0.316 | 0.252 | 0.039 | 1.000 | 0.183 | 0.150 | 0.072 | 0.209 | 0.073 | 0.048 | 0.006 | 0.109 | 0.036 | -0.242 | 0.078 | -0.094 | 0.234 | 0.031 | 0.074 | 0.029 | 0.007 | 0.104 | 0.270 | 0.053 | 0.101 | 0.241 | 0.123 | 0.164 |
| Average_MonthsLastRev | 0.079 | -0.212 | -0.031 | -0.033 | 0.183 | 1.000 | 0.559 | -0.021 | 0.088 | -0.044 | -0.023 | -0.018 | 0.040 | -0.057 | -0.101 | 0.314 | -0.106 | -0.023 | 0.018 | 0.403 | 0.031 | 0.004 | 0.042 | 0.119 | 0.019 | 0.069 | 0.026 | 0.058 | 0.182 |
| MonthsLastRev | 0.078 | -0.144 | 0.224 | -0.036 | 0.150 | 0.559 | 1.000 | -0.010 | 0.066 | -0.018 | -0.013 | -0.022 | 0.027 | -0.025 | -0.072 | 0.306 | -0.060 | -0.088 | 0.020 | 0.294 | 0.035 | 0.004 | 0.026 | 0.118 | 0.033 | 0.058 | 0.046 | 0.052 | 0.100 |
| NumConnections | -0.056 | 0.053 | 0.011 | 0.083 | 0.072 | -0.021 | -0.010 | 1.000 | 0.043 | 0.460 | 0.942 | 0.038 | -0.171 | 0.538 | -0.121 | 0.017 | -0.009 | 0.043 | 0.051 | 0.003 | 0.047 | 0.011 | 0.517 | 0.029 | 0.057 | 0.017 | 0.013 | 0.042 | 0.009 |
| Relative_Thickness | 0.017 | 0.142 | -0.043 | 0.022 | 0.209 | 0.088 | 0.066 | 0.043 | 1.000 | 0.171 | -0.026 | 0.004 | 0.638 | -0.001 | -0.941 | 0.038 | 0.213 | 0.235 | 0.034 | 0.087 | 0.025 | 0.002 | 0.097 | 0.066 | 0.118 | 0.024 | 0.438 | 0.181 | 0.019 |
| pipe_area | 0.019 | 0.164 | -0.000 | 0.049 | 0.073 | -0.044 | -0.018 | 0.460 | 0.171 | 1.000 | 0.288 | 0.018 | 0.284 | 0.955 | -0.099 | -0.022 | 0.052 | 0.021 | 0.033 | 0.024 | 0.025 | 0.001 | 0.296 | 0.046 | 0.069 | 0.019 | 0.046 | 0.075 | 0.011 |
| area_connection | -0.062 | 0.029 | 0.016 | 0.064 | 0.048 | -0.023 | -0.013 | 0.942 | -0.026 | 0.288 | 1.000 | 0.031 | -0.265 | 0.384 | -0.078 | 0.014 | -0.028 | 0.037 | 0.000 | 0.002 | 0.000 | 0.000 | 0.000 | 0.003 | 0.000 | 0.011 | 0.000 | 0.001 | 0.000 |
| incidence_area | -0.017 | -0.010 | -0.000 | 0.495 | 0.006 | -0.018 | -0.022 | 0.038 | 0.004 | 0.018 | 0.031 | 1.000 | -0.006 | 0.024 | -0.009 | -0.017 | 0.004 | 0.024 | 0.024 | 0.000 | 0.095 | 0.000 | 0.000 | 0.016 | 0.000 | 0.025 | 0.000 | 0.005 | 0.002 |
| Diameter2 | 0.106 | 0.151 | -0.057 | 0.005 | 0.109 | 0.040 | 0.027 | -0.171 | 0.638 | 0.284 | -0.265 | -0.006 | 1.000 | 0.007 | -0.381 | 0.004 | 0.159 | 0.138 | 0.014 | 0.020 | 0.009 | 0.000 | 0.070 | 0.051 | 0.179 | 0.019 | 0.203 | 0.223 | 0.019 |
| Length2 | -0.015 | 0.115 | 0.020 | 0.053 | 0.036 | -0.057 | -0.025 | 0.538 | -0.001 | 0.955 | 0.384 | 0.024 | 0.007 | 1.000 | 0.000 | -0.023 | 0.011 | -0.022 | 0.030 | 0.032 | 0.028 | 0.005 | 0.470 | 0.011 | 0.018 | 0.002 | 0.022 | 0.026 | 0.003 |
| Pressure2 | 0.033 | -0.115 | 0.031 | -0.029 | -0.242 | -0.101 | -0.072 | -0.121 | -0.941 | -0.099 | -0.078 | -0.009 | -0.381 | 0.000 | 1.000 | -0.057 | -0.178 | -0.253 | 0.004 | 0.021 | 0.004 | 0.002 | 0.102 | 0.030 | 0.882 | 0.011 | 0.032 | 0.723 | 0.013 |
| Average year Humidity (%) | 0.042 | -0.134 | -0.009 | -0.036 | 0.078 | 0.314 | 0.306 | 0.017 | 0.038 | -0.022 | 0.014 | -0.017 | 0.004 | -0.023 | -0.057 | 1.000 | -0.530 | 0.234 | 0.031 | 0.198 | 0.028 | 0.005 | 0.058 | 0.092 | 0.080 | 0.036 | 0.126 | 0.112 | 0.042 |
| Yearly Sun Hours (hours) | 0.069 | 0.105 | -0.008 | 0.009 | -0.094 | -0.106 | -0.060 | -0.009 | 0.213 | 0.052 | -0.028 | 0.004 | 0.159 | 0.011 | -0.178 | -0.530 | 1.000 | 0.097 | 0.024 | 0.195 | 0.022 | 0.006 | 0.059 | 0.083 | 0.060 | 0.031 | 0.119 | 0.092 | 0.023 |
| Population density (persons/sqkm) | -0.024 | 0.148 | -0.023 | 0.057 | 0.234 | -0.023 | -0.088 | 0.043 | 0.235 | 0.021 | 0.037 | 0.024 | 0.138 | -0.022 | -0.253 | 0.234 | 0.097 | 1.000 | 0.044 | 0.180 | 0.039 | 0.006 | 0.056 | 0.077 | 0.064 | 0.031 | 0.174 | 0.132 | 0.024 |
| No_Incidents | 0.020 | 0.018 | 0.003 | 0.627 | 0.031 | 0.018 | 0.020 | 0.051 | 0.034 | 0.033 | 0.000 | 0.024 | 0.014 | 0.030 | 0.004 | 0.031 | 0.024 | 0.044 | 1.000 | 0.009 | 0.504 | 0.000 | 0.087 | 0.037 | 0.003 | 0.028 | 0.044 | 0.029 | 0.002 |
| pipe_inspected_frequently | 0.143 | 0.155 | 0.060 | 0.012 | 0.074 | 0.403 | 0.294 | 0.003 | 0.087 | 0.024 | 0.002 | 0.000 | 0.020 | 0.032 | 0.021 | 0.198 | 0.195 | 0.180 | 0.009 | 1.000 | 0.005 | 0.001 | 0.007 | 0.038 | 0.026 | 0.013 | 0.012 | 0.035 | 0.019 |
| Incidence | 0.027 | 0.032 | 0.006 | 0.568 | 0.029 | 0.031 | 0.035 | 0.047 | 0.025 | 0.025 | 0.000 | 0.095 | 0.009 | 0.028 | 0.004 | 0.028 | 0.022 | 0.039 | 0.504 | 0.005 | 1.000 | 0.000 | 0.040 | 0.043 | 0.002 | 0.027 | 0.018 | 0.016 | 0.000 |
| NumConnectionsUnder | 0.007 | 0.011 | 0.003 | 0.000 | 0.007 | 0.004 | 0.004 | 0.011 | 0.002 | 0.001 | 0.000 | 0.000 | 0.000 | 0.005 | 0.002 | 0.005 | 0.006 | 0.006 | 0.000 | 0.001 | 0.000 | 1.000 | 0.007 | 0.003 | 0.003 | 0.008 | 0.000 | 0.001 | 0.012 |
| connection_bool | 0.097 | 0.068 | 0.011 | 0.087 | 0.104 | 0.042 | 0.026 | 0.517 | 0.097 | 0.296 | 0.000 | 0.000 | 0.070 | 0.470 | 0.102 | 0.058 | 0.059 | 0.056 | 0.087 | 0.007 | 0.040 | 0.007 | 1.000 | 0.028 | 0.108 | 0.013 | 0.001 | 0.090 | 0.011 |
| gas_natural | 0.291 | 0.519 | 0.166 | 0.119 | 0.270 | 0.119 | 0.118 | 0.029 | 0.066 | 0.046 | 0.003 | 0.016 | 0.051 | 0.011 | 0.030 | 0.092 | 0.083 | 0.077 | 0.037 | 0.038 | 0.043 | 0.003 | 0.028 | 1.000 | 0.019 | 0.267 | 0.019 | 0.038 | 0.001 |
| Material_Acrylonitrile-Butadiene-Styrene | 0.028 | 0.052 | 0.048 | 0.003 | 0.053 | 0.019 | 0.033 | 0.057 | 0.118 | 0.069 | 0.000 | 0.000 | 0.179 | 0.018 | 0.882 | 0.080 | 0.060 | 0.064 | 0.003 | 0.026 | 0.002 | 0.003 | 0.108 | 0.019 | 1.000 | 0.012 | 0.036 | 0.819 | 0.015 |
| Material_Copper | 0.101 | 0.161 | 0.051 | 0.067 | 0.101 | 0.069 | 0.058 | 0.017 | 0.024 | 0.019 | 0.011 | 0.025 | 0.019 | 0.002 | 0.011 | 0.036 | 0.031 | 0.031 | 0.028 | 0.013 | 0.027 | 0.008 | 0.013 | 0.267 | 0.012 | 1.000 | 0.007 | 0.158 | 0.003 |
| Material_Fiberglass-Reinforced Plastic | 0.084 | 0.063 | 0.017 | 0.049 | 0.241 | 0.026 | 0.046 | 0.013 | 0.438 | 0.046 | 0.000 | 0.000 | 0.203 | 0.022 | 0.032 | 0.126 | 0.119 | 0.174 | 0.044 | 0.012 | 0.018 | 0.000 | 0.001 | 0.019 | 0.036 | 0.007 | 1.000 | 0.466 | 0.008 |
| Material_Polyethylene | 0.059 | 0.072 | 0.042 | 0.031 | 0.123 | 0.058 | 0.052 | 0.042 | 0.181 | 0.075 | 0.001 | 0.005 | 0.223 | 0.026 | 0.723 | 0.112 | 0.092 | 0.132 | 0.029 | 0.035 | 0.016 | 0.001 | 0.090 | 0.038 | 0.819 | 0.158 | 0.466 | 1.000 | 0.192 |
| Material_Polypropylene | 0.164 | 0.246 | 0.082 | 0.008 | 0.164 | 0.182 | 0.100 | 0.009 | 0.019 | 0.011 | 0.000 | 0.002 | 0.019 | 0.003 | 0.013 | 0.042 | 0.023 | 0.024 | 0.002 | 0.019 | 0.000 | 0.012 | 0.011 | 0.001 | 0.015 | 0.003 | 0.008 | 0.192 | 1.000 |
| PipeId | No_Inspections | No_Incidents | InspectionYear | preventive_maintenance_rate | Age_pipe_at_inspection | pipe_inspected_frequently | Average_MonthsLastRev | MonthsLastRev | Incidence | NumConnections | NumConnectionsUnder | Relative_Thickness | pipe_area | area_connection | incidence_area | connection_bool | gas_natural | Material_Acrylonitrile-Butadiene-Styrene | Material_Copper | Material_Fiberglass-Reinforced Plastic | Material_Polyethylene | Material_Polypropylene | Diameter2 | Length2 | Pressure2 | Average year Humidity (%) | Yearly Sun Hours (hours) | Population density (persons/sqkm) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 489616 | 5 | 0.00 | 2013.00 | 0.00 | 1.00 | 1 | 21.40 | 16.00 | 0.00 | 0 | 0 | 0.16 | 1.54 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.00 | 60.72 | 0.16 | 0.55 | 107.50 | 24.99 |
| 1 | 489616 | 5 | 0.00 | 2015.00 | 0.00 | 3.00 | 1 | 21.40 | 22.00 | 0.00 | 0 | 0 | 0.16 | 1.54 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.00 | 60.72 | 0.16 | 0.55 | 107.50 | 24.99 |
| 2 | 489616 | 5 | 0.00 | 2016.00 | 0.00 | 4.00 | 1 | 21.40 | 22.00 | 0.00 | 0 | 0 | 0.16 | 1.54 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.00 | 60.72 | 0.16 | 0.55 | 107.50 | 24.99 |
| 3 | 489616 | 5 | 0.00 | 2018.00 | 0.00 | 6.00 | 1 | 21.40 | 23.00 | 0.00 | 0 | 0 | 0.16 | 1.54 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.00 | 60.72 | 0.16 | 0.55 | 107.50 | 24.99 |
| 4 | 489616 | 5 | 0.00 | 2020.00 | 0.00 | 8.00 | 1 | 21.40 | 24.00 | 0.00 | 0 | 0 | 0.16 | 1.54 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.00 | 60.72 | 0.16 | 0.55 | 107.50 | 24.99 |
| 5 | 489645 | 5 | 0.00 | 2013.00 | 0.00 | 1.00 | 1 | 21.40 | 16.00 | 0.00 | 0 | 0 | 0.22 | 0.59 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 4.33 | 0.16 | 0.55 | 107.50 | 24.99 |
| 6 | 489645 | 5 | 0.00 | 2015.00 | 0.00 | 3.00 | 1 | 21.40 | 22.00 | 0.00 | 0 | 0 | 0.22 | 0.59 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 4.33 | 0.16 | 0.55 | 107.50 | 24.99 |
| 7 | 489645 | 5 | 0.00 | 2016.00 | 0.00 | 4.00 | 1 | 21.40 | 22.00 | 0.00 | 0 | 0 | 0.22 | 0.59 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 4.33 | 0.16 | 0.55 | 107.50 | 24.99 |
| 8 | 489645 | 5 | 0.00 | 2018.00 | 0.00 | 6.00 | 1 | 21.40 | 23.00 | 0.00 | 0 | 0 | 0.22 | 0.59 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 4.33 | 0.16 | 0.55 | 107.50 | 24.99 |
| 9 | 489645 | 5 | 0.00 | 2020.00 | 0.00 | 8.00 | 1 | 21.40 | 24.00 | 0.00 | 0 | 0 | 0.22 | 0.59 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 4.33 | 0.16 | 0.55 | 107.50 | 24.99 |
| PipeId | No_Inspections | No_Incidents | InspectionYear | preventive_maintenance_rate | Age_pipe_at_inspection | pipe_inspected_frequently | Average_MonthsLastRev | MonthsLastRev | Incidence | NumConnections | NumConnectionsUnder | Relative_Thickness | pipe_area | area_connection | incidence_area | connection_bool | gas_natural | Material_Acrylonitrile-Butadiene-Styrene | Material_Copper | Material_Fiberglass-Reinforced Plastic | Material_Polyethylene | Material_Polypropylene | Diameter2 | Length2 | Pressure2 | Average year Humidity (%) | Yearly Sun Hours (hours) | Population density (persons/sqkm) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5446321 | 412794648 | 1 | 0.00 | 2014.00 | 0.00 | 3.00 | 1 | 24.00 | 24.00 | 0.00 | 0 | 0 | 0.02 | 19.26 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.00 | 9467.29 | 16.00 | 0.57 | 108.40 | 45.79 |
| 5446322 | 412794740 | 1 | 0.00 | 2014.00 | 0.00 | 3.00 | 1 | 24.00 | 24.00 | 0.00 | 0 | 0 | 0.02 | 21.56 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 5816.81 | 16.00 | 0.57 | 108.40 | 45.79 |
| 5446323 | 412794856 | 1 | 0.00 | 2014.00 | 0.00 | 3.00 | 1 | 24.00 | 24.00 | 0.00 | 0 | 0 | 0.02 | 20.50 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.00 | 10730.89 | 16.00 | 0.57 | 108.40 | 45.79 |
| 5446324 | 412795048 | 1 | 0.00 | 2014.00 | 0.00 | 3.00 | 1 | 24.00 | 24.00 | 0.00 | 0 | 0 | 0.03 | 0.42 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 1.46 | 16.00 | 0.57 | 108.40 | 45.79 |
| 5446325 | 412795215 | 1 | 0.00 | 2014.00 | 0.00 | 3.00 | 1 | 24.00 | 24.00 | 0.00 | 0 | 0 | 0.02 | 18.77 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 4406.57 | 16.00 | 0.57 | 108.40 | 45.79 |
| 5446326 | 412795512 | 1 | 0.00 | 2014.00 | 0.00 | 3.00 | 1 | 24.00 | 24.00 | 0.00 | 0 | 0 | 0.02 | 0.55 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.00 | 7.70 | 16.00 | 0.57 | 108.40 | 45.79 |
| 5446327 | 412796243 | 1 | 0.00 | 2014.00 | 0.00 | 3.00 | 1 | 24.00 | 24.00 | 0.00 | 0 | 0 | 0.02 | 2.09 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 54.83 | 16.00 | 0.57 | 108.40 | 45.79 |
| 5446328 | 412796261 | 1 | 0.00 | 2014.00 | 0.00 | 3.00 | 1 | 24.00 | 24.00 | 0.00 | 0 | 0 | 0.02 | 2.33 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 68.05 | 16.00 | 0.57 | 108.40 | 45.79 |
| 5446329 | 412796288 | 1 | 0.00 | 2014.00 | 0.00 | 3.00 | 1 | 24.00 | 24.00 | 0.00 | 0 | 0 | 0.02 | 2.68 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 90.08 | 16.00 | 0.57 | 108.40 | 45.79 |
| 5446330 | 412796529 | 1 | 0.00 | 2014.00 | 0.00 | 3.00 | 1 | 24.00 | 24.00 | 0.00 | 0 | 0 | 0.02 | 1.12 | 0.00 | 0.00 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0.01 | 15.82 | 16.00 | 0.57 | 108.40 | 45.79 |